﻿CREATE VIEW [dbo].[vwDimCustomer]
AS
SELECT CustomerId, 
		CustomerCode, 
		FirstName, 
		LastName, 
		FirstName + ' ' + LastName as FullName,
		Company, 
		Address, 
		City, 
		State, 
		Country, 
		PostalCode, 
		Phone, 
		Fax, 
		Email
FROM     dbo.DimCustomer
